package com.ctvit.sms.platform.domain;
import java.util.Date;
import com.ctvit.framework.domain.BaseBean;
/**
* domain类
* 对应查询语句:select a.*,b.z_reg_desc
from
(
	select a.z_reg_id,sum(cnt0) as cnt0,sum(cnt1) as cnt1,sum(cnt2) as cnt2,sum(cnt3) as cnt3,sum(cnt4) as cnt4,sum(cnt5) as cnt5,sum(cnt6) as cnt6,sum(cnt7) as cnt7
	from
	(
		select z_reg_id,(case z_msg_status when '0'  then 1 else 0 end ) as cnt0,(case z_msg_status when '1'  then 1 else 0 end ) as cnt1,
		(case z_msg_status when '2'  then 1 else 0 end ) as cnt2,(case z_msg_status when '3'  then 1 else 0 end ) as cnt3,
		(case z_msg_status when '3'  then 1 else 0 end ) as cnt4,(case z_msg_status when '4'  then 1 else 0 end ) as cnt5,
		(case z_msg_status when '6'  then 1 else 0 end ) as cnt6,1 as cnt7
		from t_msg_req
	)a group by a.z_reg_id
) a left join t_msg_reg b on a.z_reg_id=b.z_reg_no
* 
*/ 
public class ReqStatRegno extends BaseBean{
	/*
	* 字段:     Z_REG_ID
	* 数据库类型:CHAR
	* 说明:     null
	* 
	*/
	private String zRegId;
	/*
	* 字段:     CNT0
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt0;
	/*
	* 字段:     CNT1
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt1;
	/*
	* 字段:     CNT2
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt2;
	/*
	* 字段:     CNT3
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt3;
	/*
	* 字段:     CNT4
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt4;
	/*
	* 字段:     CNT5
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt5;
	/*
	* 字段:     CNT6
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt6;
	/*
	* 字段:     CNT7
	* 数据库类型:NUMBER
	* 说明:     null
	* 
	*/
	private Long cnt7;
	/*
	* 字段:     Z_REG_DESC
	* 数据库类型:VARCHAR2
	* 说明:     null
	* 
	*/
	private String zRegDesc;
	
	/**
	 * null.
	 *
	 * @return ZRegId type:String
	 */
	public String getZRegId() {
		return zRegId;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZRegId(String newvalue) {
		this.zRegId = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt0 type:Long
	 */
	public Long getCnt0() {
		return cnt0;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt0(Long newvalue) {
		this.cnt0 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt1 type:Long
	 */
	public Long getCnt1() {
		return cnt1;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt1(Long newvalue) {
		this.cnt1 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt2 type:Long
	 */
	public Long getCnt2() {
		return cnt2;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt2(Long newvalue) {
		this.cnt2 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt3 type:Long
	 */
	public Long getCnt3() {
		return cnt3;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt3(Long newvalue) {
		this.cnt3 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt4 type:Long
	 */
	public Long getCnt4() {
		return cnt4;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt4(Long newvalue) {
		this.cnt4 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt5 type:Long
	 */
	public Long getCnt5() {
		return cnt5;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt5(Long newvalue) {
		this.cnt5 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt6 type:Long
	 */
	public Long getCnt6() {
		return cnt6;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt6(Long newvalue) {
		this.cnt6 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Cnt7 type:Long
	 */
	public Long getCnt7() {
		return cnt7;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setCnt7(Long newvalue) {
		this.cnt7 = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZRegDesc type:String
	 */
	public String getZRegDesc() {
		return zRegDesc;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZRegDesc(String newvalue) {
		this.zRegDesc = newvalue;
	}
}

